package com.bojx.report.dao;
import java.util.List;

import com.jfinal.plugin.activerecord.Db;


public class StatisticDao {
	public Integer  countUploadedNum(Integer year,Integer month){
	    String  sql= Db.getSql("statistic.countUploadedNum");
		return Db.queryInt(sql,year,month);
	}

	public Integer countTotalNum() {
		String  sql= Db.getSql("statistic.countTotalNum");
	    return Db.queryInt(sql);
	}

	public List<String> queryAllBanks() {
		String sql=Db.getSql("statistic.queryAllBanks");
		return Db.query(sql);
	}

	public List<String> queryUploadedBanks(Integer year, Integer month) {
		String sql=Db.getSql("statistic.queryUploadedBanks");
		return Db.query(sql,year,month);
	}

	public Integer countUploadedNumByQuarter(Integer year, Integer quarter) {
		 String  sql= Db.getSql("statistic.countUploadedNumByQuarter");
	     return Db.queryInt(sql,year,quarter);
	}

	public List<String> queryUploadedBanksByQuarter(Integer year, Integer quarter) {
		String sql=Db.getSql("statistic.queryUploadedBanksByQuarter");
		return Db.query(sql,year,quarter);
	}
}
